<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>Administrator</Author>
  <LastAuthor>wuxu</LastAuthor>
  <Created>2019-03-30T01:17:12Z</Created>
  <Version>15.00</Version>
 </DocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <AllowPNG/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>9225</WindowHeight>
  <WindowWidth>20490</WindowWidth>
  <WindowTopX>0</WindowTopX>
  <WindowTopY>0</WindowTopY>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="m39604021984">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604022004">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604022024">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604022044">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604022064">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604022084">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604022104">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604019072">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604019092">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604019112">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604019132">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604019172">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604019192">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
   <NumberFormat ss:Format="Short Date"/>
  </Style>
  <Style ss:ID="m39604019212">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604019232">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="m39604019252">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s62">
   <Alignment ss:Vertical="Center"/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="8" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s63">
   <Alignment ss:Vertical="Center" ss:WrapText="1"/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="8" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s64">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s77">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s79">
   <Alignment ss:Horizontal="Left" ss:Vertical="Center" ss:WrapText="1"/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="20" ss:Color="#000000"
    ss:Bold="1"/>
  </Style>
  <Style ss:ID="s80">
   <Alignment ss:Vertical="Center" ss:WrapText="1"/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="20" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s93">
   <Alignment ss:Vertical="Center"/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000" ss:Bold="1"/>
  </Style>
  <Style ss:ID="s94">
   <Alignment ss:Vertical="Center" ss:WrapText="1"/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000" ss:Bold="1"/>
  </Style>
  <Style ss:ID="s95">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s105">
   <Alignment ss:Horizontal="Center" ss:Vertical="Center" ss:WrapText="1"/>
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="9" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s106">
   <Borders>
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1"/>
    <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1"/>
   </Borders>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
  </Style>
 </Styles>
 <#if SizeNameNode?size lt 24>
 <#assign columnCount = 29 + 2 />
 <#else>
 <#assign columnCount = SizeNameNode?size + 5 + 2 />
 </#if>
 <Worksheet ss:Name="发货明细">
  <#assign linesLength = 0 />
  <#if LinesDescList?size gt SumQuantity?size> 
  <#assign linesLength = LinesDescList?size />
  <#else>
  <#assign linesLength = SumQuantity?size /> 
  </#if>
  <#if SizeNameNode?size lte 24>
  <Table ss:ExpandedColumnCount="${columnCount}" ss:ExpandedRowCount="${LinesList?size + 8 + linesLength}" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5">
  <#else>
  <Table ss:ExpandedColumnCount="${SizeNameNode?size + 5 + 2}" ss:ExpandedRowCount="${LinesList?size + 8 + linesLength}" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5">
  </#if>
   <Column ss:Width="28.5"/>
   <Column ss:Width="48"/>
   <Column ss:Width="78.75"/>
   <Column ss:Width="38.25"/>
   <Column ss:Width="35.25" ss:Span="${columnCount - 5}"/>
   <Row ss:AutoFitHeight="0" ss:Height="15">
    <Cell ss:StyleID="s62"><Data ss:Type="String"> 萬益德（大連）實業有限公司</Data></Cell>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:StyleID="s63"/>
    <Cell ss:Index="15" ss:MergeAcross="1" ss:StyleID="m39604019072"><Data
      ss:Type="String">客&#160;&#160;户</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604019092"><Data ss:Type="String">${HeaderEntity.getCustomerName()!""}</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m39604019112"><Data ss:Type="String">主合同号</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604019132"><Data ss:Type="String">${HeaderEntity.getSoNo()!""}</Data></Cell>
    <Cell ss:StyleID="s77"/>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:MergeAcross="5" ss:MergeDown="1" ss:StyleID="s79"><ss:Data
      ss:Type="String" xmlns="http://www.w3.org/TR/REC-html40"><B><Font
        html:Color="#000000">发货明细表</Font></B><Font html:Color="#000000"> </Font><Font
       html:Size="8" html:Color="#000000">（打印日期：${.now?string("yyyy-MM-dd")}） </Font></ss:Data></Cell>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:Index="15" ss:MergeAcross="1" ss:StyleID="m39604019172"><Data
      ss:Type="String">发货日期</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604019192"><Data ss:Type="DateTime">${HeaderEntity.getDateOfDelivery()?string("yyyy-MM-dd")!""}</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m39604019212"><Data ss:Type="String">加工厂</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604019232"><Data ss:Type="String">${HeaderEntity.getGarmentFactoryName()!""}</Data></Cell>
    <Cell ss:StyleID="s77"/>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:Index="7" ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:StyleID="s80"/>
    <Cell ss:Index="15" ss:MergeAcross="1" ss:StyleID="m39604019252"><Data
      ss:Type="String">箱&#160;&#160;装</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604021984"><Data ss:Type="Number">${HeaderEntity.getInCase()!""}</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="m39604022004"><Data ss:Type="String">制表人</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604022024"><Data ss:Type="String">${HeaderEntity.getUpdatedByName()!""}</Data></Cell>
    <Cell ss:StyleID="s77"/>
   </Row>
   <#assign _CartonNo = 0 />
   <Row ss:Index="5" ss:AutoFitHeight="0">
    <Cell ss:StyleID="s64"><Data ss:Type="String">箱号</Data></Cell>
    <Cell ss:StyleID="s64"><Data ss:Type="String">发货地</Data></Cell>
    <Cell ss:StyleID="s64"><Data ss:Type="String">款号</Data></Cell>
    <Cell ss:StyleID="s64"><Data ss:Type="String">颜色</Data></Cell>
    <#list SizeNameNode as node>
    <Cell ss:StyleID="s64"><Data ss:Type="String">${node}</Data></Cell>
    </#list>    
    <#if SizeNameNode?size lt 24>
    <#list (SizeNameNode?size + 5)..28 as t>
    <Cell ss:StyleID="s64"/>
    </#list>
    </#if>
    <Cell ss:StyleID="s77"/>
   </Row>
   <#if LinesList?exists && LinesList??>
   <#list LinesList as item>
   <Row ss:AutoFitHeight="0" ss:Height="27.75">
    <#if _CartonNo == item.getCartonNo()>
    <Cell ss:StyleID="s64"></Cell>
    <#else>
    <Cell ss:StyleID="s64"><Data ss:Type="Number">${item.getCartonNo()!''}</Data></Cell>
    <#assign _CartonNo = item.getCartonNo() />
    </#if>    
    <Cell ss:StyleID="s64"><Data ss:Type="String">${item.getDestination()!''}</Data></Cell>
    <Cell ss:StyleID="s64"><Data ss:Type="String">${item.getStyleNo()!''}</Data></Cell>
    <Cell ss:StyleID="s64"><Data ss:Type="String">${item.getColourName()!''}&#10;${item.getColourNumber()!''}</Data></Cell>
    <#if SizeNameNode?exists && SizeNameNode??>
    <#list SizeNameNode as sizeName>
    <#assign hasNum = false />
    <#list item.getInBoxMemoJson() as inBox>
    <#if inBox["SizeName"] == sizeName>
    <Cell ss:StyleID="s64"><Data ss:Type="Number">${inBox["InBox"]}</Data></Cell>
    <#assign hasNum = true />
    <#break/>
    </#if>
    </#list>
    <#if hasNum == false>
    <Cell ss:StyleID="s64"/>
    </#if>
    </#list>
    <#if SizeNameNode?size lt 24>
        <#list (SizeNameNode?size + 5)..28 as t>
            <Cell ss:StyleID="s64"/>
        </#list>
    </#if>
    </#if>
    <#if SizeNameNode?size lt 24>
        <Cell ss:StyleID="s105" ss:Formula="=SUM(RC[-24]:RC[-1])"><Data ss:Type="Number">60</Data></Cell>
    <#else>
        <Cell ss:StyleID="s105" ss:Formula="=SUM(RC[-${SizeNameNode?size}]:RC[-1])"><Data ss:Type="Number">60</Data></Cell>
    </#if>
    <#if item.getStyleNo()?contains("/")>
        <Cell ss:StyleID="s106"><Data ss:Type="String">SET</Data></Cell>
    <#else>
        <Cell ss:StyleID="s106"><Data ss:Type="String">PCS</Data></Cell>
    </#if>
   </Row>
   </#list>
   </#if>
   <Row ss:Index="${LinesList?size + 7}" ss:AutoFitHeight="0">
    <Cell ss:StyleID="s93"><Data ss:Type="String">※【补充说明】</Data></Cell>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s93"><Data ss:Type="String">【汇总】</Data></Cell>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
    <Cell ss:StyleID="s94"/>
   </Row>
   <Row ss:AutoFitHeight="0">
    <Cell ss:StyleID="s95"><Data ss:Type="String">箱号</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">发货地</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">款号</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">颜色</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">码数</Data></Cell>
    <Cell ss:MergeAcross="2" ss:StyleID="m39604022044"><Data ss:Type="String">箱单数量(SET）</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604022064"><Data ss:Type="String">实际装货数量(SET)船前先だし</Data></Cell>
    <Cell ss:Index="16" ss:MergeAcross="2" ss:StyleID="s95"><Data ss:Type="String">款号</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="String">颜色</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="String">发货地</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="String">数量</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="String">箱数</Data></Cell>
   </Row>
   <#if LinesDescList?size gt SumQuantity?size> 
   <#if LinesDescList?exists && LinesDescList??>
   <#list LinesDescList as item>
   <Row ss:AutoFitHeight="0" ss:Height="27.75">
    <Cell ss:StyleID="s95"><Data ss:Type="Number">${item_pathitem.getCartonNo()!''}</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">${item.getDestination()!''}</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">${item.getStyleNo()!''}</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">${item.getColourName()!''}&#10;${item.getColourNumber()!''}</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">${item.getSizeName()!''}</Data></Cell>
    <Cell ss:MergeAcross="2" ss:StyleID="m39604022084"><Data ss:Type="Number">${item.getInBox()}</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604022104"><Data ss:Type="String">${item.getDescription()}</Data></Cell>
    
    <#if SumQuantity?exists && SumQuantity[item_index]??>
    <#assign instance = SumQuantity[item_index] />
    <Cell ss:Index="16" ss:MergeAcross="2" ss:StyleID="s95"><Data ss:Type="String">${instance["styleno"]!''}</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="String">${instance["colourname"]}&#10;${instance["colournumber"]}</Data></Cell>
        <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="String">${instance["destination"]!''}</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="Number">${instance["quantity"]!''}</Data></Cell>
    </#if>
   </Row>
   </#list>
   </#if>
   <#else>
   <#if SumQuantity?exists && SumQuantity??>
   <#list SumQuantity as item>
   <Row ss:AutoFitHeight="0" ss:Height="27.75">
    <#if LinesDescList?exists && LinesDescList[item_index]??>
    <#assign instance = LinesDescList[item_index] />
    <Cell ss:StyleID="s95"><Data ss:Type="Number">${instance.getCartonNo()!''}</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">${instance.getDestination()!''}</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">${instance.getStyleNo()!''}</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">${instance.getColourName()!''}&#10;${instance.getColourNumber()!''}</Data></Cell>
    <Cell ss:StyleID="s95"><Data ss:Type="String">${instance.getSizeName()!''}</Data></Cell>
    <Cell ss:MergeAcross="2" ss:StyleID="m39604022084"><Data ss:Type="Number">${instance.getInBox()}</Data></Cell>
    <Cell ss:MergeAcross="4" ss:StyleID="m39604022104"><Data ss:Type="String">${instance.getDescription()}</Data></Cell>
    </#if>
    <Cell ss:Index="16" ss:MergeAcross="2" ss:StyleID="s95"><Data ss:Type="String">${item["styleno"]!''}</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="String">${item["colourname"]}&#10;${item["colournumber"]}</Data></Cell>
        <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="String">${item["destination"]!''}</Data></Cell>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="Number">${item["quantity"]!''}</Data></Cell>
    
    <#if CartonAmount?exists && CartonAmount??>
    <#assign isbox = false />
    <#list CartonAmount as boxamount>
    <#if boxamount["styleno"] == item["styleno"] && boxamount["colourname"] == item["colourname"] && boxamount["destination"] == item["destination"]>
    <Cell ss:MergeAcross="1" ss:StyleID="s95"><Data ss:Type="Number">${boxamount["cartonamount"]!''}</Data></Cell>
    <#assign isbox = true />
    <#break/>
    </#if>
    </#list>
    <#if isbox == false>
    <Cell ss:MergeAcross="1" ss:StyleID="s95" />
    </#if>
    </#if>
   </Row>
   </#list>
   </#if>
   </#if>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Unsynced/>
   <Selected/>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
